Syntax Definitions

Returns the Absolute Value of a number.

Checks the source query against the target query and returns True if any of the records in the source query came after those in the target query.

Returns the age in years from the value supplied to the current system date.

Returns the age in years from the value supplied in the first argument to the value supplied in the second argument.

Returns the date of an anniversary.

Returns the number of days to an anniversary.

This function will extract the area label from a postcode in standard UK format.

Takes all the child records that match the optional filter query and sums the values for each parent record. Then divides the sum by the number of child records for the parent that match the criteria.

Takes all the child records for each parent that match the optional filter criteria and fall within the specified index and returns the average for each parent record.

Returns a number that represents the average difference between each of a child records of the parent.

This function will return a number that indicates which element of a band each record falls into.

Takes the child records for each parent and sorts them by the field specified in the fieldName parameter.

Specialised function to allow querying on standard campaign history and response tables.

Turns a delimited list of data values into a categorised data banding.

Returns the value from a numeric field rounded up to the next whole number.

Converts the value supplied into the equivalent ASCII character for that number.

Returns the ASCII character code for the first character of the string supplied.

Joins several text values together into a single text value.

Converts one datatype to another.

Returns the number of child records for each parent that match the optional filter criteria, and fall within the specified index.

Returns the number of distinct values in a field on the child table for each parent record.

Returns the current date and time.

Adds a time interval to the input date.

Returns just the date part from a value that includes the date and time.

Returns the day component of the date supplied. Any leading zeros are removed.

Returns the day in a month for the date supplied, from 1 to 31.

Returns the day of week component of the date supplied. Any leading zeros are removed.

Returns the day of the year for the date supplied. Any leading zeros are removed.

Returns the number of whole days between two given dates.

Decodes values within a discrete field to an alternative set of values.

The geographic field to extract the area section from.

This function will extract the district label from a postcode in standard UK format.

Returns e raised to the power of the value in a numeric field.

For each parent record, returns the value from the first child record. The child records are looked at in natural unsorted order.

When used within a query the function produces a recordset that contains only one record for each unique value of the argument.

Flags the first occurrence of a record that meets the criteria supplied in the filterQuery argument.

Returns the value from a numeric field rounded down to the next whole number.

The format function allows the output format of a Geographic field to be changed into a number of different formats.

A specialised function that selects all the leads within a radius specified in metres of a central geographic point.

This function returns the internal area number of standard UK postcode.

This function returns the internal area number of a standard UK postcode.

Returns the distance, in metres from the OSGB reference point, near the Scilly Isles, due east to a specified postcode.

Returns the ISBA TV region as derived from the postcode.

Returns the distance, in metres from the OSGB reference point, near the Scilly Isles, due north to a specified postcode.

This function returns the internal sector number of a standard UK postcode.

This function returns just the hour from a date time field.

Checks whether the condition is true or false and returns the value specified in the true argument if the condition is met or in the false argument if it is not.

Returns a number for each child record that indicates its index.

Returns the position of the first character that matches the specified string.

Imports data from a key file.

Returns field label if present.

Returns the largest value from the supplied values.

Returns the value from the last child record for each parent record.

Using the table name supplied the function returns a date and time that represents the last time that a delete action was carried out on the specified table.

Using the table name supplied the function returns the value of the primary key on the last record of the specified table.

Using the table name supplied the function returns the last date and time that the specified table was subject to an update or append of records.

Returns the number of characters specified from the left-hand end of a string.

Returns the number of characters in the specified string.

Returns the Natural Logarithm (base 2.71828) for the values in a numeric field.

Returns the Common Logarithm (base 10) for the values in a numeric field.

Converts all the characters of the specified string into lower case.

For each parent, returns a number that represents the maximum difference between each of the child records.

Returns the maximum value of a field on the child table for each parent record.

Takes all the child records for each parent that match the optional filter criteria and fall within the specified index and returns the maximum for each parent record.

Returns the median value of the child records for each parent record.

For each parent, returns a number that represents the minimum difference between each of the child records.

Returns the minimum value of the field on the child table for each parent record.

Takes all the child records for each parent that match the optional filter criteria and fall within the specified index and returns the minimum for each parent record.

This function returns just the minute from a date time field.

Return the most frequent value of a field.

A specialised function that selects leads from a model.

Returns just the month element of the date supplied.

Returns the number of whole months between two given dates.

Allows N records to be selected from a table across a 1 to many join based on the value of a field at the many end.

Returns the number of working days between two dates.

This function inverts the recordset that is created by the expression argument.

Flags child records that are after records that meet the criteria given in the source query.

Flags child records that are before records that meet the criteria given in the source query.

Retrieves a sibling value.

When used within a query the function produces a recordset that contains a sample of records.

When used within a query the function produces a recordset that contains one record for each parent record defined by the relationship between the tables.

Using the table name supplied the function returns a date and time that represents the penultimate time that a delete action was carried out on the specified table.

Using the table name supplied the function returns the value of the primary key on the last record of the specified table at the time of the penultimate update.

Using the table name supplied the function returns the penultimate date and time that the specified table was subject to an update or append of records.

Raises the value in a numeric field to a specified power.

Uppercases the first letter of each separate word in the specified string.

Returns the quarter value (1-4) from a date time field.

Returns a random number between 1 and the value specified.

Returns a number for each child record that indicates its recency.

Returns the Unique Record Number for each record.

Returns a new string in which all occurrences of the match string are replaced by the replace string.

Returns the number of characters specified from the right hand end of a string.

Rounds the values in a numeric field.

When used within a query the function produces a recordset of only a number of the records from the input recordset.

When used within a query the function produces a recordset of only a percentage of the records from the input recordset.

Returns a number that represents the standard deviation of a parents child records.

Returns a number that represents the standard deviation of a parents child records. However, only the number of records specified by the index parameter will be used.

This function returns just the second from a date time field.

This function will extract the sector label from a postcode in standard UK format.

Returns -1 for negative values in a field, 0 for zero values and 1 for positive values.

When used within a query the function produces a recordset of the specified number of records.

Returns the smallest value from the supplied values.

Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English.

Returns the square root of a value in a numeric field.

Returns the square of a value in a numeric field.

This function returns the 5th percentile value for every record in a table.

This function returns the 95th percentile value for every record in a table.

Returns the same value for every record in a table and allows the resultant summary statistic for a field to be compared against each individual value for the field.

This function returns the maximum value for every record in a table.

This function returns the mean value for every record in a table.

This function returns the median value for every record in a table.

This function returns the minimum value for every record in a table.

This function returns the mode value for every record in a table.

This function returns the record count value for every record in a table.

This function returns the standard deviation value for every record in a table.

This function returns the sum value for every record in a table.

Removes all spaces from a string.

Returns a number of characters from the middle of a string.

A query string representing the domain of records to include.

The function increases the flexibility of the query language by mimicking the results of rolling a selection.

Function to allow querying of Tags by name or id.

A specialised function that selects leads from tagged data.

Returns the time part from a datetime value.

Returns a new date value based on adding an interval to the date supplied.

When used within a query the function produces a recordset that contains the top or bottom n records based on their values for a given numeric field.

This function is used to return the difference between the band index of the same record on different bands.

The function returns the Unicode character for the numeric value supplied.

The function returns the Unicode character code for the character value supplied.

Uppercases all the characters in the string supplied.

Returns the day of the week for the date supplied.

Returns the year portion of the date supplied.